Jassif Team Institution

Products அட்டவணை

+-----------+----------------+------------+-------+
| ProductID | ProductName    | CategoryID | Price |
+-----------+----------------+------------+-------+
| 1         | Chais          | 1          | 18    |
| 2         | Chang          | 1          | 19    |
| 3         | Aniseed Syrup  | 2          | 10    |
+-----------+----------------+------------+-------+

Categories அட்டவணை

+------------+----------------+----------------------------------------------------+
| CategoryID | CategoryName   | Description                                        |
+------------+----------------+----------------------------------------------------+
| 1          | Beverages      | Soft drinks, coffees, teas, beers, and ales        |
| 2          | Condiments     | Sweet and savory sauces, relishes, spreads, etc.   |
| 3          | Confections    | Desserts, candies, and sweet breads                |
+------------+----------------+----------------------------------------------------+

உதாரணம்

Products மற்றும் Categories-ஐ INNER JOIN keyword-ஐப் பயன்படுத்தி இணைக்கவும்:

SELECT ProductID, ProductName, CategoryName
FROM Products
INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID;

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

உதாரணம்

அட்டவணைப் பெயர்களைக் குறிப்பிடவும்:

SELECT Products.ProductID, Products.ProductName, Categories.CategoryName
FROM Products
INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID;

உதாரணம்

JOIN என்பது INNER JOIN-க்கு சமமானது:

SELECT Products.ProductID, Products.ProductName, Categories.CategoryName
FROM Products
JOIN Categories ON Products.CategoryID = Categories.CategoryID;

Shippers அட்டவணை

+-----------+-------------------+------------------+
| ShipperID | ShipperName       | Phone            |
+-----------+-------------------+------------------+
| 1         | Speedy Express    | (503) 555-9831   |
| 2         | United Package    | (503) 555-3199   |
| 3         | Federal Shipping  | (503) 555-9931   |
+-----------+-------------------+------------------+

உதாரணம்

SELECT Orders.OrderID, Customers.CustomerName, Shippers.ShipperName
FROM ((Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID)
INNER JOIN Shippers ON Orders.ShipperID = Shippers.ShipperID);